Applying changes to the Pivotal Greenplum target

You can apply changes in one of two modes:

• Transactional apply Mode
• Batch-Optimized Apply Mode

For information on how to use the transactional apply mode, see Apply Changes Settings.

Transactional apply Mode

In this mode, the Pivotal Greenplum database writes all the change records to CSV files as DML statement. When a file is ready, the Pivotal Greenplum database creates an external Web table that uses the gpfdist server to read changes from the file and executes the DML statements in each row returned from the external Web table. When the changes are applied, the file is deleted.

Batch-Optimized Apply Mode

In this mode, the Pivotal Greenplum database writes net changes only to CSV files. When a file is ready, the Pivotal Greenplum database uses an external table that uses the gpfdist server to read the net changes from the file to a temporary table. The net changes are then applied to the target tables in the most efficient way. When the changes are applied, the file is deleted.